Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_COPY_CORRUPTION

This view lists corrupt block ranges in datafile copies. It corresponds to the `V$COPY_CORRUPTION` view.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for the target database. Use this column to form a join with almost any other catalog view.
`DBINC_KEY` | `NUMBER` | The primary key for the incarnation of the target database. Use this column to form a join with `RC_DATABASE_INCARNATION`.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`RECID` | `NUMBER` | The record identifier from `V$COPY_CORRUPTION`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`STAMP` | `NUMBER` | The stamp from `V$COPY_CORRUPTION`. `RECID` and `STAMP` form a concatenated primary key that uniquely identifies this record in the target database control file.
`CDF_KEY` | `NUMBER` | The primary key of the datafile copy in the recovery catalog. If you issue the `LIST` command while connected to the recovery catalog, this value appears in the `KEY` column of the output. Use this column to form a join with `RC_DATAFILE_COPY`.
`COPY_RECID` | `NUMBER` | The `RECID` from `RC_DATAFILE_COPY`. This value is propagated from the control file.
`COPY_STAMP` | `NUMBER` | The `STAMP` from `RC_DATAFILE_COPY`. This value is propagated from the control file.
`FILE#` | `NUMBER` | The absolute file number of the datafile.
`CREATION_CHANGE#` | `NUMBER` | The creation SCN of this data file. Because file numbers can be reused, `FILE#` and `CREATION_CHANGE#` are both required to uniquely identify a specified file over the life of the database.
`BLOCK#` | `NUMBER` | The block number of the first corrupted block in the file.
`BLOCKS` | `NUMBER` | The number of corrupted blocks found beginning with `BLOCK#`.
`CORRUPTION_CHANGE#` | `NUMBER` | For media corrupt blocks, this value is zero. For logically corrupt blocks, this value is the lowest SCN in the blocks in this corrupt range.
`MARKED_CORRUPT` | `VARCHAR2(3)` | `YES` if this corruption was not previously detected by the database server or `NO` if it was already known by the database server.
`CORRUPTION_TYPE` | `VARCHAR2(9)` | Same as `RC_DATABASE_BLOCK_CORRUPTION.CORRUPTION_TYPE`.